Tabela CO_MEALHISTORY

Definicja tabeli CO_MEALHISTORY

Name

CO_MEALHISTORY

Code

CO_MEALHISTORY

Comment

 


Lista kolumn tabeli CO_MEALHISTORY

Name

Code

CO_MEALHISTORYID

CO_MEALHISTORYID

HISTORYDATE

HISTORYDATE

MEALTYPEID

MEALTYPEID

PRICE

PRICE

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_MEALHISTORYID tabeli CO_MEALHISTORY

Definicja kolumny CO_MEALHISTORYID tabeli CO_MEALHISTORY

Name

CO_MEALHISTORYID

Code

CO_MEALHISTORYID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HISTORYDATE tabeli CO_MEALHISTORY

Definicja kolumny HISTORYDATE tabeli CO_MEALHISTORY

Name

HISTORYDATE

Code

HISTORYDATE

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna MEALTYPEID tabeli CO_MEALHISTORY

Definicja kolumny MEALTYPEID tabeli CO_MEALHISTORY

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PRICE tabeli CO_MEALHISTORY

Definicja kolumny PRICE tabeli CO_MEALHISTORY

Name

PRICE

Code

PRICE

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_MEALHISTORY

Definicja kolumny INSERTDATE tabeli CO_MEALHISTORY

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_MEALHISTORY

Definicja kolumny INSERTINGPERSON tabeli CO_MEALHISTORY

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_MEALHISTORY

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_MEALHISTORY

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_MEALHISTORY

Definicja kolumny LASTMODIFIEDDT tabeli CO_MEALHISTORY

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_MEALHISTORY

Name

Code

Primary

PK_CO_MEALHISTORY

PK_CO_MEALHISTORY

X


Klucz PK_CO_MEALHISTORY tabeli CO_MEALHISTORY

Definicja klucza PK_CO_MEALHISTORY tabeli CO_MEALHISTORY

Name

PK_CO_MEALHISTORY

Code

PK_CO_MEALHISTORY

Primary

Yes

Comment